import sqlite3

connection = sqlite3.connect("DataBase.db")
cursor = connection.cursor()
# cursor.execute("""CREATE TABLE files (
#     uuid VARCHAR(36) PRIMARY KEY,
#     path VARCHAR(255) NOT NULL
# );""")
cursor.execute("""CREATE TABLE archive (
    id INT AUTO_INCREMENT PRIMARY KEY,
    uuid VARCHAR(36) NOT NULL,
    title VARCHAR(255) NOT NULL,
    content TEXT,
    comments TEXT,
    category VARCHAR(100),
    tag VARCHAR(100),
    unixTime BIGINT NOT NULL,
    UNIQUE (uuid)  -- 确保 uuid 是唯一的
);""")
connection.commit()
cursor.close()
connection.close()